package com.vcredit.creditcat.framework.util;

public class ConstantsUtil {

	/**
	 * excel 相关常量
	 */

	/**
	 * 导出header
	 */
	// 物料
	public static final String[] Materheaders = { "物料代码", "物料中文名称", "物料英文名称", "物料类型 1:未知 2:成品  3:半成品 4:原材料",
			"保质期 1:是 2:否", "规格", "型号", "计量单位", "采购提前期", "所属组织", "助记码", "物料基本分类", "辅助计量单位", "条形码", "物料图片", "毛重", "净重",
			"长度", "宽度", "高度", "体积", "参考单价", "所属公司", "重量单位", "长度单位", "体积单位", "库存单位", "是否启用批次号",
			"物料财务类型 1:原材料 2:半成品 3:成品 4:委外", "物料仓库类型1:原料仓 2:成品仓 3:半成品仓 4:实验仓 5:冻结库等6:第三方库存7:供应商库存 ", "生产组织", "生产周期",
			"采购组织", "单据状态 1:新增 2:保存 3:提交 4:作废 5:审核 6:关闭" };

	public static final String[] FeedbackHeaders = { "No", "客户id", "联系人姓名", "联系信息（邮箱或手机号）", "评价类型（0:用户反馈）", "评价内容",
			"状态(0：无效 1：有效)", "设备描述", "创建时间", "最后更新时间" };
	public static final String[] channeHeader = { "渠道名称", "注册数", "激活数" };
	public static final String[] channeHeaders = { "渠道名称", "注册数", "激活数", "创建时间" };
	/**
	 * 导出excel的功能名称
	 */
	public static final String feedback = "FeedBack";
	public static final String banner = "Banner";
	public static final String creditCard = "信用卡";
	public static final String channe = "channe";

	public static final String channeTitleSheet = "总计";

	public static final String defaultSheet="数据统计";
	public static final String channelSheet="每日数据";
	/**
	 * excel linux路径
	 *
	 */
	public static final String ExcelPath = "/usr/local/excel/";
	public static final String WinPath = "D:/test";
	/**
	 * excel格式
	 */
	public static final String excel03 = ".xls";
	public static final String excel07 = ".xlsx";
	// 过滤所有特殊字符的正则表表达式
	public static final String REMOVE_ALL_SPECIAL_CHARACTERS_REGEX = "[`~!@#$%^&*()+=|{}':;',\\[\\].<>/?~！@#￥%……&*（）——+|{}【】‘；：”“’。，、？]";

}
